Dataset statistics
| Number of variables | 15 |
|---|---|
| Number of observations | 35952 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 16.8 MiB |
| Average record size in memory | 488.9 B |
Variable types
| Categorical | 6 |
|---|---|
| Numeric | 9 |
Make has a high cardinality: 127 distinct values | High cardinality |
Model has a high cardinality: 3608 distinct values | High cardinality |
Engine Displacement is highly correlated with Cylinders and 8 other fields | High correlation |
Cylinders is highly correlated with Engine Displacement and 8 other fields | High correlation |
Fuel Barrels/Year is highly correlated with Engine Displacement and 9 other fields | High correlation |
City MPG is highly correlated with Engine Displacement and 8 other fields | High correlation |
Highway MPG is highly correlated with Engine Displacement and 8 other fields | High correlation |
Combined MPG is highly correlated with Engine Displacement and 8 other fields | High correlation |
CO2 Emission Grams/Mile is highly correlated with Engine Displacement and 9 other fields | High correlation |
Fuel Cost/Year is highly correlated with Engine Displacement and 7 other fields | High correlation |
Year is highly correlated with Transmission and 1 other fields | High correlation |
Transmission is highly correlated with Year and 10 other fields | High correlation |
Drivetrain is highly correlated with Transmission and 1 other fields | High correlation |
Vehicle Class is highly correlated with Year and 10 other fields | High correlation |
Fuel Type is highly correlated with Transmission and 2 other fields | High correlation |
Reproduction
| Analysis started | 2022-11-01 08:31:12.219039 |
|---|---|
| Analysis finished | 2022-11-01 08:31:21.764970 |
| Duration | 9.55 seconds |
| Software version | pandas-profiling v3.4.0 |
| Download configuration | config.json |
| Distinct | 127 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| Chevrolet | |
|---|---|
| Ford | |
| Dodge | |
| GMC | |
| Toyota | 1836 |
| Other values (122) |
Length
| Max length | 34 |
|---|---|
| Median length | 27 |
| Mean length | 6.321289497 |
| Min length | 3 |
Characters and Unicode
| Total characters | 227263 |
|---|---|
| Distinct characters | 52 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 24 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | AM General |
|---|---|
| 2nd row | AM General |
| 3rd row | AM General |
| 4th row | AM General |
| 5th row | ASC Incorporated |
Common Values
| Value | Count | Frequency (%) |
| Chevrolet | 3643 | 10.1% |
| Ford | 2946 | 8.2% |
| Dodge | 2360 | 6.6% |
| GMC | 2347 | 6.5% |
| Toyota | 1836 | 5.1% |
| BMW | 1677 | 4.7% |
| Mercedes-Benz | 1284 | 3.6% |
| Nissan | 1253 | 3.5% |
| Volkswagen | 1047 | 2.9% |
| Mitsubishi | 950 | 2.6% |
| Other values (117) | 16609 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| chevrolet | 3643 | 9.9% |
| ford | 2946 | 8.0% |
| dodge | 2360 | 6.4% |
| gmc | 2349 | 6.4% |
| toyota | 1836 | 5.0% |
| bmw | 1680 | 4.6% |
| mercedes-benz | 1284 | 3.5% |
| nissan | 1253 | 3.4% |
| volkswagen | 1047 | 2.9% |
| mitsubishi | 950 | 2.6% |
| Other values (167) | 17322 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 22251 | 9.8% |
| o | 20505 | 9.0% |
| r | 14426 | 6.3% |
| a | 14328 | 6.3% |
| i | 11206 | 4.9% |
| d | 10984 | 4.8% |
| s | 10114 | 4.5% |
| l | 9391 | 4.1% |
| t | 9333 | 4.1% |
| u | 9103 | 4.0% |
| Other values (42) | 95622 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 177779 | |
| Uppercase Letter | 47223 | 20.8% |
| Dash Punctuation | 1447 | 0.6% |
| Space Separator | 719 | 0.3% |
| Other Punctuation | 95 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 22251 | |
| o | 20505 | |
| r | 14426 | 8.1% |
| a | 14328 | 8.1% |
| i | 11206 | 6.3% |
| d | 10984 | 6.2% |
| s | 10114 | 5.7% |
| l | 9391 | 5.3% |
| t | 9333 | 5.2% |
| u | 9103 | 5.1% |
| Other values (14) | 46138 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 8417 | |
| C | 7240 | |
| B | 3639 | 7.7% |
| F | 3213 | 6.8% |
| G | 2521 | 5.3% |
| D | 2458 | 5.2% |
| P | 2259 | 4.8% |
| S | 2126 | 4.5% |
| T | 1868 | 4.0% |
| V | 1781 | 3.8% |
| Other values (14) | 11701 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 85 | |
| , | 10 | 10.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1447 |
Space Separator
| Value | Count | Frequency (%) |
| 719 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 225002 | |
| Common | 2261 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 22251 | 9.9% |
| o | 20505 | 9.1% |
| r | 14426 | 6.4% |
| a | 14328 | 6.4% |
| i | 11206 | 5.0% |
| d | 10984 | 4.9% |
| s | 10114 | 4.5% |
| l | 9391 | 4.2% |
| t | 9333 | 4.1% |
| u | 9103 | 4.0% |
| Other values (38) | 93361 |
Common
| Value | Count | Frequency (%) |
| - | 1447 | |
| 719 | ||
| . | 85 | 3.8% |
| , | 10 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 227263 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 22251 | 9.8% |
| o | 20505 | 9.0% |
| r | 14426 | 6.3% |
| a | 14328 | 6.3% |
| i | 11206 | 4.9% |
| d | 10984 | 4.8% |
| s | 10114 | 4.5% |
| l | 9391 | 4.1% |
| t | 9333 | 4.1% |
| u | 9103 | 4.0% |
| Other values (42) | 95622 |
| Distinct | 3608 |
|---|---|
| Distinct (%) | 10.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.3 MiB |
| F150 Pickup 2WD | 197 |
|---|---|
| F150 Pickup 4WD | 179 |
| Truck 2WD | 173 |
| Mustang | 170 |
| Jetta | 169 |
| Other values (3603) |
Length
| Max length | 47 |
|---|---|
| Median length | 34 |
| Mean length | 11.33708834 |
| Min length | 1 |
Characters and Unicode
| Total characters | 407591 |
|---|---|
| Distinct characters | 69 |
| Distinct categories | 9 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 631 ? |
|---|---|
| Unique (%) | 1.8% |
Sample
| 1st row | DJ Po Vehicle 2WD |
|---|---|
| 2nd row | FJ8c Post Office |
| 3rd row | Post Office DJ5 2WD |
| 4th row | Post Office DJ8 2WD |
| 5th row | GNX |
Common Values
| Value | Count | Frequency (%) |
| F150 Pickup 2WD | 197 | 0.5% |
| F150 Pickup 4WD | 179 | 0.5% |
| Truck 2WD | 173 | 0.5% |
| Mustang | 170 | 0.5% |
| Jetta | 169 | 0.5% |
| Ranger Pickup 2WD | 161 | 0.4% |
| Sierra 1500 4WD | 149 | 0.4% |
| Sierra 1500 2WD | 146 | 0.4% |
| Camaro | 146 | 0.4% |
| Civic | 139 | 0.4% |
| Other values (3598) | 34323 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2wd | 6921 | 9.3% |
| 4wd | 4913 | 6.6% |
| pickup | 3011 | 4.1% |
| awd | 1929 | 2.6% |
| wagon | 1908 | 2.6% |
| 1500 | 1159 | 1.6% |
| fwd | 1029 | 1.4% |
| convertible | 970 | 1.3% |
| van | 666 | 0.9% |
| coupe | 665 | 0.9% |
| Other values (1814) | 51018 |
Most occurring characters
| Value | Count | Frequency (%) |
| 38290 | 9.4% | |
| a | 26703 | 6.6% |
| r | 23857 | 5.9% |
| e | 21668 | 5.3% |
| o | 18715 | 4.6% |
| W | 17524 | 4.3% |
| D | 16715 | 4.1% |
| i | 16534 | 4.1% |
| n | 15592 | 3.8% |
| 0 | 14424 | 3.5% |
| Other values (59) | 197569 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 212103 | |
| Uppercase Letter | 96298 | |
| Decimal Number | 55267 | 13.6% |
| Space Separator | 38290 | 9.4% |
| Other Punctuation | 2877 | 0.7% |
| Dash Punctuation | 1088 | 0.3% |
| Open Punctuation | 831 | 0.2% |
| Close Punctuation | 831 | 0.2% |
| Math Symbol | 6 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 26703 | |
| r | 23857 | |
| e | 21668 | |
| o | 18715 | 8.8% |
| i | 16534 | 7.8% |
| n | 15592 | 7.4% |
| t | 11821 | 5.6% |
| u | 10125 | 4.8% |
| c | 8634 | 4.1% |
| l | 8008 | 3.8% |
| Other values (16) | 50446 |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 17524 | |
| D | 16715 | |
| C | 10067 | |
| S | 8602 | |
| P | 4618 | 4.8% |
| A | 4610 | 4.8% |
| T | 4160 | 4.3% |
| F | 3833 | 4.0% |
| V | 2978 | 3.1% |
| E | 2956 | 3.1% |
| Other values (16) | 20235 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 14424 | |
| 2 | 10697 | |
| 5 | 8506 | |
| 4 | 7624 | |
| 1 | 5908 | |
| 3 | 3573 | 6.5% |
| 6 | 1590 | 2.9% |
| 9 | 1131 | 2.0% |
| 8 | 954 | 1.7% |
| 7 | 860 | 1.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 2639 | |
| . | 238 | 8.3% |
Space Separator
| Value | Count | Frequency (%) |
| 38290 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1088 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 831 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 831 |
Math Symbol
| Value | Count | Frequency (%) |
| > | 6 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 308401 | |
| Common | 99190 | 24.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 26703 | 8.7% |
| r | 23857 | 7.7% |
| e | 21668 | 7.0% |
| o | 18715 | 6.1% |
| W | 17524 | 5.7% |
| D | 16715 | 5.4% |
| i | 16534 | 5.4% |
| n | 15592 | 5.1% |
| t | 11821 | 3.8% |
| u | 10125 | 3.3% |
| Other values (42) | 129147 |
Common
| Value | Count | Frequency (%) |
| 38290 | ||
| 0 | 14424 | 14.5% |
| 2 | 10697 | 10.8% |
| 5 | 8506 | 8.6% |
| 4 | 7624 | 7.7% |
| 1 | 5908 | 6.0% |
| 3 | 3573 | 3.6% |
| / | 2639 | 2.7% |
| 6 | 1590 | 1.6% |
| 9 | 1131 | 1.1% |
| Other values (7) | 4808 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 407591 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 38290 | 9.4% | |
| a | 26703 | 6.6% |
| r | 23857 | 5.9% |
| e | 21668 | 5.3% |
| o | 18715 | 4.6% |
| W | 17524 | 4.3% |
| D | 16715 | 4.1% |
| i | 16534 | 4.1% |
| n | 15592 | 3.8% |
| 0 | 14424 | 3.5% |
| Other values (59) | 197569 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2000.7164 |
| Minimum | 1984 |
|---|---|
| Maximum | 2017 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 1984 |
|---|---|
| 5-th percentile | 1985 |
| Q1 | 1991 |
| median | 2001 |
| Q3 | 2010 |
| 95-th percentile | 2016 |
| Maximum | 2017 |
| Range | 33 |
| Interquartile range (IQR) | 19 |
Descriptive statistics
| Standard deviation | 10.08528955 |
|---|---|
| Coefficient of variation (CV) | 0.005040839147 |
| Kurtosis | -1.309415619 |
| Mean | 2000.7164 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | -0.05659508101 |
| Sum | 71929756 |
| Variance | 101.7130653 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 1985 | 1581 | 4.4% |
| 2015 | 1264 | 3.5% |
| 2016 | 1228 | 3.4% |
| 2014 | 1211 | 3.4% |
| 1987 | 1198 | 3.3% |
| 1986 | 1188 | 3.3% |
| 2008 | 1184 | 3.3% |
| 2009 | 1183 | 3.3% |
| 2013 | 1168 | 3.2% |
| 2005 | 1156 | 3.2% |
| Other values (24) | 23591 |
| Value | Count | Frequency (%) |
| 1984 | 645 | |
| 1985 | 1581 | |
| 1986 | 1188 | |
| 1987 | 1198 | |
| 1988 | 1119 | |
| 1989 | 1127 | |
| 1990 | 1068 | |
| 1991 | 1122 | |
| 1992 | 1107 | |
| 1993 | 1077 |
| Value | Count | Frequency (%) |
| 2017 | 857 | |
| 2016 | 1228 | |
| 2015 | 1264 | |
| 2014 | 1211 | |
| 2013 | 1168 | |
| 2012 | 1139 | |
| 2011 | 1124 | |
| 2010 | 1108 | |
| 2009 | 1183 | |
| 2008 | 1184 |
| Distinct | 65 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.338492991 |
| Minimum | 0.6 |
|---|---|
| Maximum | 8.4 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 0.6 |
|---|---|
| 5-th percentile | 1.6 |
| Q1 | 2.2 |
| median | 3 |
| Q3 | 4.3 |
| 95-th percentile | 5.9 |
| Maximum | 8.4 |
| Range | 7.8 |
| Interquartile range (IQR) | 2.1 |
Descriptive statistics
| Standard deviation | 1.359395386 |
|---|---|
| Coefficient of variation (CV) | 0.4071883302 |
| Kurtosis | -0.5744958571 |
| Mean | 3.338492991 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.6053760668 |
| Sum | 120025.5 |
| Variance | 1.847955816 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2 | 3342 | 9.3% |
| 3 | 2869 | 8.0% |
| 2.5 | 2286 | 6.4% |
| 2.4 | 1877 | 5.2% |
| 3.5 | 1452 | 4.0% |
| 1.8 | 1439 | 4.0% |
| 1.6 | 1343 | 3.7% |
| 5 | 1329 | 3.7% |
| 4.3 | 1319 | 3.7% |
| 2.2 | 1237 | 3.4% |
| Other values (55) | 17459 |
| Value | Count | Frequency (%) |
| 0.6 | 3 | < 0.1% |
| 0.9 | 4 | < 0.1% |
| 1 | 162 | 0.5% |
| 1.1 | 8 | < 0.1% |
| 1.2 | 38 | 0.1% |
| 1.3 | 178 | 0.5% |
| 1.4 | 188 | 0.5% |
| 1.5 | 667 | |
| 1.6 | 1343 | |
| 1.7 | 46 | 0.1% |
| Value | Count | Frequency (%) |
| 8.4 | 11 | < 0.1% |
| 8.3 | 9 | < 0.1% |
| 8 | 23 | 0.1% |
| 7.4 | 4 | < 0.1% |
| 7 | 10 | < 0.1% |
| 6.8 | 126 | |
| 6.7 | 69 | |
| 6.6 | 20 | 0.1% |
| 6.5 | 111 | |
| 6.4 | 31 | 0.1% |
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.765075656 |
| Minimum | 2 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 4 |
| median | 6 |
| Q3 | 6 |
| 95-th percentile | 8 |
| Maximum | 16 |
| Range | 14 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.755268232 |
|---|---|
| Coefficient of variation (CV) | 0.3044657757 |
| Kurtosis | 0.9226341968 |
| Mean | 5.765075656 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.8462732618 |
| Sum | 207266 |
| Variance | 3.080966565 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 4 | 13494 | |
| 6 | 12765 | |
| 8 | 7998 | |
| 5 | 723 | 2.0% |
| 12 | 562 | 1.6% |
| 3 | 201 | 0.6% |
| 10 | 153 | 0.4% |
| 2 | 48 | 0.1% |
| 16 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 48 | 0.1% |
| 3 | 201 | 0.6% |
| 4 | 13494 | |
| 5 | 723 | 2.0% |
| 6 | 12765 | |
| 8 | 7998 | |
| 10 | 153 | 0.4% |
| 12 | 562 | 1.6% |
| 16 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 16 | 8 | < 0.1% |
| 12 | 562 | 1.6% |
| 10 | 153 | 0.4% |
| 8 | 7998 | |
| 6 | 12765 | |
| 5 | 723 | 2.0% |
| 4 | 13494 | |
| 3 | 201 | 0.6% |
| 2 | 48 | 0.1% |
| Distinct | 45 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.4 MiB |
| Automatic 4-spd | |
|---|---|
| Manual 5-spd | |
| Automatic (S6) | |
| Automatic 3-spd | |
| Manual 6-spd | |
| Other values (40) |
Length
| Max length | 32 |
|---|---|
| Median length | 17 |
| Mean length | 14.09454272 |
| Min length | 8 |
Characters and Unicode
| Total characters | 506727 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 7 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Automatic 3-spd |
|---|---|
| 2nd row | Automatic 3-spd |
| 3rd row | Automatic 3-spd |
| 4th row | Automatic 3-spd |
| 5th row | Automatic 4-spd |
Common Values
| Value | Count | Frequency (%) |
| Automatic 4-spd | 10585 | |
| Manual 5-spd | 7787 | |
| Automatic (S6) | 2631 | 7.3% |
| Automatic 3-spd | 2597 | 7.2% |
| Manual 6-spd | 2423 | 6.7% |
| Automatic 5-spd | 2171 | 6.0% |
| Automatic 6-spd | 1432 | 4.0% |
| Manual 4-spd | 1306 | 3.6% |
| Automatic (S8) | 960 | 2.7% |
| Automatic (S5) | 822 | 2.3% |
| Other values (35) | 3238 | 9.0% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| automatic | 23408 | |
| 4-spd | 11891 | |
| manual | 11659 | |
| 5-spd | 9958 | |
| 6-spd | 3855 | 5.3% |
| 3-spd | 2671 | 3.7% |
| s6 | 2631 | 3.6% |
| s8 | 960 | 1.3% |
| s5 | 822 | 1.1% |
| 7-spd | 730 | 1.0% |
| Other values (34) | 3789 | 5.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 49432 | 9.8% |
| t | 48373 | 9.5% |
| 36422 | 7.2% | |
| u | 35952 | 7.1% |
| s | 30115 | 5.9% |
| - | 30038 | 5.9% |
| d | 29440 | 5.8% |
| p | 29440 | 5.8% |
| A | 25191 | 5.0% |
| o | 24965 | 4.9% |
| Other values (24) | 167359 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 348690 | |
| Uppercase Letter | 43282 | 8.5% |
| Space Separator | 36422 | 7.2% |
| Decimal Number | 35271 | 7.0% |
| Dash Punctuation | 30038 | 5.9% |
| Open Punctuation | 6512 | 1.3% |
| Close Punctuation | 6512 | 1.3% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 49432 | |
| t | 48373 | |
| u | 35952 | |
| s | 30115 | |
| d | 29440 | |
| p | 29440 | |
| o | 24965 | |
| i | 24758 | |
| c | 23408 | |
| m | 23408 | |
| Other values (7) | 29399 |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 12122 | |
| 5 | 10795 | |
| 6 | 6849 | |
| 3 | 2673 | 7.6% |
| 7 | 1470 | 4.2% |
| 8 | 1241 | 3.5% |
| 9 | 117 | 0.3% |
| 1 | 4 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 25191 | |
| M | 12307 | |
| S | 5529 | 12.8% |
| V | 251 | 0.6% |
| L | 4 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 36422 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 30038 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 6512 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 6512 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 391972 | |
| Common | 114755 | 22.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 49432 | |
| t | 48373 | |
| u | 35952 | |
| s | 30115 | |
| d | 29440 | |
| p | 29440 | |
| A | 25191 | 6.4% |
| o | 24965 | 6.4% |
| i | 24758 | 6.3% |
| c | 23408 | 6.0% |
| Other values (12) | 70898 |
Common
| Value | Count | Frequency (%) |
| 36422 | ||
| - | 30038 | |
| 4 | 12122 | 10.6% |
| 5 | 10795 | 9.4% |
| 6 | 6849 | 6.0% |
| ( | 6512 | 5.7% |
| ) | 6512 | 5.7% |
| 3 | 2673 | 2.3% |
| 7 | 1470 | 1.3% |
| 8 | 1241 | 1.1% |
| Other values (2) | 121 | 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 506727 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 49432 | 9.8% |
| t | 48373 | 9.5% |
| 36422 | 7.2% | |
| u | 35952 | 7.1% |
| s | 30115 | 5.9% |
| - | 30038 | 5.9% |
| d | 29440 | 5.8% |
| p | 29440 | 5.8% |
| A | 25191 | 5.0% |
| o | 24965 | 4.9% |
| Other values (24) | 167359 |
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Front-Wheel Drive | |
|---|---|
| Rear-Wheel Drive | |
| 4-Wheel or All-Wheel Drive | |
| All-Wheel Drive | |
| 4-Wheel Drive | 1058 |
| Other values (3) | 582 |
Length
| Max length | 26 |
|---|---|
| Median length | 23 |
| Mean length | 18.02219626 |
| Min length | 13 |
Characters and Unicode
| Total characters | 647934 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2-Wheel Drive |
|---|---|
| 2nd row | 2-Wheel Drive |
| 3rd row | Rear-Wheel Drive |
| 4th row | Rear-Wheel Drive |
| 5th row | Rear-Wheel Drive |
Common Values
| Value | Count | Frequency (%) |
| Front-Wheel Drive | 13044 | |
| Rear-Wheel Drive | 12726 | |
| 4-Wheel or All-Wheel Drive | 6503 | |
| All-Wheel Drive | 2039 | 5.7% |
| 4-Wheel Drive | 1058 | 2.9% |
| 2-Wheel Drive | 423 | 1.2% |
| Part-time 4-Wheel Drive | 158 | 0.4% |
| 2-Wheel Drive, Front | 1 | < 0.1% |
Length
Histogram of lengths of the category
Category Frequency Plot
| Value | Count | Frequency (%) |
| drive | 35952 | |
| front-wheel | 13044 | 15.3% |
| rear-wheel | 12726 | 15.0% |
| all-wheel | 8542 | 10.0% |
| 4-wheel | 7719 | 9.1% |
| or | 6503 | 7.6% |
| 2-wheel | 424 | 0.5% |
| part-time | 158 | 0.2% |
| front | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 133746 | |
| r | 68384 | |
| l | 59539 | |
| 49117 | 7.6% | |
| - | 42613 | 6.6% |
| W | 42455 | 6.6% |
| h | 42455 | 6.6% |
| i | 36110 | 5.6% |
| D | 35952 | 5.5% |
| v | 35952 | 5.5% |
| Other values (12) | 101611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 435182 | |
| Uppercase Letter | 112878 | 17.4% |
| Space Separator | 49117 | 7.6% |
| Dash Punctuation | 42613 | 6.6% |
| Decimal Number | 8143 | 1.3% |
| Other Punctuation | 1 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 133746 | |
| r | 68384 | |
| l | 59539 | |
| h | 42455 | 9.8% |
| i | 36110 | 8.3% |
| v | 35952 | 8.3% |
| o | 19548 | 4.5% |
| t | 13361 | 3.1% |
| n | 13045 | 3.0% |
| a | 12884 | 3.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| W | 42455 | |
| D | 35952 | |
| F | 13045 | 11.6% |
| R | 12726 | 11.3% |
| A | 8542 | 7.6% |
| P | 158 | 0.1% |
Decimal Number
| Value | Count | Frequency (%) |
| 4 | 7719 | |
| 2 | 424 | 5.2% |
Space Separator
| Value | Count | Frequency (%) |
| 49117 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 42613 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 548060 | |
| Common | 99874 | 15.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 133746 | |
| r | 68384 | |
| l | 59539 | |
| W | 42455 | 7.7% |
| h | 42455 | 7.7% |
| i | 36110 | 6.6% |
| D | 35952 | 6.6% |
| v | 35952 | 6.6% |
| o | 19548 | 3.6% |
| t | 13361 | 2.4% |
| Other values (7) | 60558 |
Common
| Value | Count | Frequency (%) |
| 49117 | ||
| - | 42613 | |
| 4 | 7719 | 7.7% |
| 2 | 424 | 0.4% |
| , | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 647934 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 133746 | |
| r | 68384 | |
| l | 59539 | |
| 49117 | 7.6% | |
| - | 42613 | 6.6% |
| W | 42455 | 6.6% |
| h | 42455 | 6.6% |
| i | 36110 | 5.6% |
| D | 35952 | 5.5% |
| v | 35952 | 5.5% |
| Other values (12) | 101611 |
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.6 MiB |
| Compact Cars | |
|---|---|
| Subcompact Cars | |
| Midsize Cars | |
| Standard Pickup Trucks | |
| Sport Utility Vehicle - 4WD | |
| Other values (29) |
Length
| Max length | 34 |
|---|---|
| Median length | 28 |
| Mean length | 17.86056409 |
| Min length | 4 |
Characters and Unicode
| Total characters | 642123 |
|---|---|
| Distinct characters | 38 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | Special Purpose Vehicle 2WD |
|---|---|
| 2nd row | Special Purpose Vehicle 2WD |
| 3rd row | Special Purpose Vehicle 2WD |
| 4th row | Special Purpose Vehicle 2WD |
| 5th row | Midsize Cars |
Common Values
| Value | Count | Frequency (%) |
| Compact Cars | 5185 | |
| Subcompact Cars | 4374 | |
| Midsize Cars | 4063 | |
| Standard Pickup Trucks | 2311 | 6.4% |
| Sport Utility Vehicle - 4WD | 2081 | 5.8% |
| Two Seaters | 1784 | 5.0% |
| Large Cars | 1742 | 4.8% |
| Sport Utility Vehicle - 2WD | 1615 | 4.5% |
| Special Purpose Vehicles | 1404 | 3.9% |
| Small Station Wagons | 1371 | 3.8% |
| Other values (24) | 10022 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| cars | 16576 | |
| vehicle | 5990 | 5.9% |
| pickup | 5540 | 5.5% |
| trucks | 5536 | 5.5% |
| compact | 5185 | 5.1% |
| sport | 5152 | 5.1% |
| utility | 5152 | 5.1% |
| standard | 5003 | 4.9% |
| 2wd | 4622 | 4.6% |
| midsize | 4479 | 4.4% |
| Other values (22) | 37859 |
Most occurring characters
| Value | Count | Frequency (%) |
| 65142 | 10.1% | |
| a | 54931 | 8.6% |
| i | 41312 | 6.4% |
| r | 39411 | 6.1% |
| t | 37854 | 5.9% |
| s | 37548 | 5.8% |
| c | 37081 | 5.8% |
| e | 31682 | 4.9% |
| p | 26688 | 4.2% |
| o | 25225 | 3.9% |
| Other values (28) | 245249 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 455736 | |
| Uppercase Letter | 106721 | 16.6% |
| Space Separator | 65142 | 10.1% |
| Decimal Number | 9076 | 1.4% |
| Dash Punctuation | 4707 | 0.7% |
| Other Punctuation | 741 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 54931 | |
| i | 41312 | |
| r | 39411 | 8.6% |
| t | 37854 | 8.3% |
| s | 37548 | 8.2% |
| c | 37081 | 8.1% |
| e | 31682 | 7.0% |
| p | 26688 | 5.9% |
| o | 25225 | 5.5% |
| l | 21524 | 4.7% |
| Other values (12) | 102480 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 24343 | |
| C | 22193 | |
| W | 11488 | |
| V | 9254 | 8.7% |
| D | 9068 | 8.5% |
| P | 8089 | 7.6% |
| T | 8057 | 7.5% |
| M | 6702 | 6.3% |
| U | 5152 | 4.8% |
| L | 2375 | 2.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 4628 | |
| 4 | 4448 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 733 | |
| / | 8 | 1.1% |
Space Separator
| Value | Count | Frequency (%) |
| 65142 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4707 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 562457 | |
| Common | 79666 | 12.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 54931 | 9.8% |
| i | 41312 | 7.3% |
| r | 39411 | 7.0% |
| t | 37854 | 6.7% |
| s | 37548 | 6.7% |
| c | 37081 | 6.6% |
| e | 31682 | 5.6% |
| p | 26688 | 4.7% |
| o | 25225 | 4.5% |
| S | 24343 | 4.3% |
| Other values (22) | 206382 |
Common
| Value | Count | Frequency (%) |
| 65142 | ||
| - | 4707 | 5.9% |
| 2 | 4628 | 5.8% |
| 4 | 4448 | 5.6% |
| , | 733 | 0.9% |
| / | 8 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 642123 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 65142 | 10.1% | |
| a | 54931 | 8.6% |
| i | 41312 | 6.4% |
| r | 39411 | 6.1% |
| t | 37854 | 5.9% |
| s | 37548 | 5.8% |
| c | 37081 | 5.8% |
| e | 31682 | 4.9% |
| p | 26688 | 4.2% |
| o | 25225 | 3.9% |
| Other values (28) | 245249 |
| Distinct | 13 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 2.2 MiB |
| Regular | |
|---|---|
| Premium | |
| Gasoline or E85 | 1195 |
| Diesel | 911 |
| Premium or E85 | 121 |
| Other values (8) | 217 |
Length
| Max length | 27 |
|---|---|
| Median length | 7 |
| Mean length | 7.298926346 |
| Min length | 3 |
Characters and Unicode
| Total characters | 262411 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Regular |
|---|---|
| 2nd row | Regular |
| 3rd row | Regular |
| 4th row | Regular |
| 5th row | Premium |
Common Values
| Value | Count | Frequency (%) |
| Regular | 23587 | |
| Premium | 9921 | |
| Gasoline or E85 | 1195 | 3.3% |
| Diesel | 911 | 2.5% |
| Premium or E85 | 121 | 0.3% |
| Midgrade | 74 | 0.2% |
| CNG | 60 | 0.2% |
| Premium and Electricity | 20 | 0.1% |
| Gasoline or natural gas | 20 | 0.1% |
| Premium Gas or Electricity | 17 | < 0.1% |
| Other values (3) | 26 | 0.1% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| regular | 23605 | |
| premium | 10079 | |
| or | 1363 | 3.5% |
| e85 | 1316 | 3.4% |
| gasoline | 1223 | 3.2% |
| diesel | 911 | 2.3% |
| midgrade | 74 | 0.2% |
| cng | 60 | 0.2% |
| electricity | 55 | 0.1% |
| gas | 55 | 0.1% |
| Other values (3) | 64 | 0.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 36866 | |
| r | 35204 | |
| u | 33704 | |
| l | 25814 | |
| a | 25041 | |
| g | 23699 | |
| R | 23605 | |
| m | 20158 | |
| i | 12397 | 4.7% |
| P | 10079 | 3.8% |
| Other values (17) | 15844 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 219448 | |
| Uppercase Letter | 37478 | 14.3% |
| Space Separator | 2853 | 1.1% |
| Decimal Number | 2632 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 36866 | |
| r | 35204 | |
| u | 33704 | |
| l | 25814 | |
| a | 25041 | |
| g | 23699 | |
| m | 20158 | |
| i | 12397 | 5.6% |
| o | 2594 | 1.2% |
| s | 2189 | 1.0% |
| Other values (6) | 1782 | 0.8% |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 23605 | |
| P | 10079 | |
| E | 1371 | 3.7% |
| G | 1318 | 3.5% |
| D | 911 | 2.4% |
| M | 74 | 0.2% |
| C | 60 | 0.2% |
| N | 60 | 0.2% |
Decimal Number
| Value | Count | Frequency (%) |
| 5 | 1316 | |
| 8 | 1316 |
Space Separator
| Value | Count | Frequency (%) |
| 2853 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 256926 | |
| Common | 5485 | 2.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 36866 | |
| r | 35204 | |
| u | 33704 | |
| l | 25814 | |
| a | 25041 | |
| g | 23699 | |
| R | 23605 | |
| m | 20158 | |
| i | 12397 | 4.8% |
| P | 10079 | 3.9% |
| Other values (14) | 10359 | 4.0% |
Common
| Value | Count | Frequency (%) |
| 2853 | ||
| 5 | 1316 | |
| 8 | 1316 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 262411 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 36866 | |
| r | 35204 | |
| u | 33704 | |
| l | 25814 | |
| a | 25041 | |
| g | 23699 | |
| R | 23605 | |
| m | 20158 | |
| i | 12397 | 4.7% |
| P | 10079 | 3.8% |
| Other values (17) | 15844 |
| Distinct | 123 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.6090555 |
| Minimum | 0.06 |
|---|---|
| Maximum | 47.08714286 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 0.06 |
|---|---|
| 5-th percentile | 11.36586207 |
| Q1 | 14.69942308 |
| median | 17.34789474 |
| Q3 | 20.600625 |
| 95-th percentile | 25.35461538 |
| Maximum | 47.08714286 |
| Range | 47.02714286 |
| Interquartile range (IQR) | 5.901201923 |
Descriptive statistics
| Standard deviation | 4.467282686 |
|---|---|
| Coefficient of variation (CV) | 0.2536923508 |
| Kurtosis | 1.468284879 |
| Mean | 17.6090555 |
| Median Absolute Deviation (MAD) | 3.017025172 |
| Skewness | 0.6382712089 |
| Sum | 633080.7634 |
| Variance | 19.9566146 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 18.31166667 | 3492 | 9.7% |
| 17.34789474 | 3203 | 8.9% |
| 15.69571429 | 3120 | 8.7% |
| 16.4805 | 3061 | 8.5% |
| 19.38882353 | 2277 | 6.3% |
| 20.600625 | 2226 | 6.2% |
| 14.98227273 | 2213 | 6.2% |
| 21.974 | 2210 | 6.1% |
| 23.54357143 | 1940 | 5.4% |
| 14.33086957 | 1762 | 4.9% |
| Other values (113) | 10448 |
| Value | Count | Frequency (%) |
| 0.06 | 4 | < 0.1% |
| 0.06642857143 | 11 | |
| 0.06888888889 | 3 | < 0.1% |
| 0.08086956522 | 1 | < 0.1% |
| 0.08454545455 | 2 | < 0.1% |
| 0.1033333333 | 2 | < 0.1% |
| 0.1094117647 | 3 | < 0.1% |
| 0.11625 | 3 | < 0.1% |
| 0.124 | 1 | < 0.1% |
| 0.1328571429 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 47.08714286 | 5 | < 0.1% |
| 41.20125 | 21 | 0.1% |
| 36.62333333 | 36 | 0.1% |
| 32.961 | 130 | 0.4% |
| 29.96454545 | 439 | 1.2% |
| 27.4675 | 730 | |
| 27.29892857 | 5 | < 0.1% |
| 25.479 | 30 | 0.1% |
| 25.35461538 | 1245 | |
| 23.8865625 | 86 | 0.2% |
| Distinct | 48 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.6461393 |
| Minimum | 6 |
|---|---|
| Maximum | 58 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 6 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 15 |
| median | 17 |
| Q3 | 20 |
| 95-th percentile | 26 |
| Maximum | 58 |
| Range | 52 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 4.769348814 |
|---|---|
| Coefficient of variation (CV) | 0.2702771826 |
| Kurtosis | 5.087694024 |
| Mean | 17.6461393 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.468995384 |
| Sum | 634414 |
| Variance | 22.74668811 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=48)
| Value | Count | Frequency (%) |
| 15 | 4158 | |
| 17 | 3690 | |
| 16 | 3577 | |
| 18 | 3547 | |
| 14 | 2760 | 7.7% |
| 19 | 2629 | 7.3% |
| 21 | 1993 | 5.5% |
| 13 | 1959 | 5.4% |
| 20 | 1905 | 5.3% |
| 12 | 1512 | 4.2% |
| Other values (38) | 8222 |
| Value | Count | Frequency (%) |
| 6 | 5 | < 0.1% |
| 7 | 20 | 0.1% |
| 8 | 84 | 0.2% |
| 9 | 194 | 0.5% |
| 10 | 516 | 1.4% |
| 11 | 1422 | 4.0% |
| 12 | 1512 | 4.2% |
| 13 | 1959 | |
| 14 | 2760 | |
| 15 | 4158 |
| Value | Count | Frequency (%) |
| 58 | 2 | < 0.1% |
| 54 | 2 | < 0.1% |
| 53 | 5 | < 0.1% |
| 51 | 10 | |
| 50 | 2 | < 0.1% |
| 49 | 3 | < 0.1% |
| 48 | 12 | |
| 47 | 2 | < 0.1% |
| 45 | 6 | < 0.1% |
| 44 | 16 |
| Distinct | 49 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 23.88064642 |
| Minimum | 9 |
|---|---|
| Maximum | 61 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 15 |
| Q1 | 20 |
| median | 24 |
| Q3 | 27 |
| 95-th percentile | 34 |
| Maximum | 61 |
| Range | 52 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.890876356 |
|---|---|
| Coefficient of variation (CV) | 0.2466799371 |
| Kurtosis | 0.934351372 |
| Mean | 23.88064642 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 0.6175942148 |
| Sum | 858557 |
| Variance | 34.70242424 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=49)
| Value | Count | Frequency (%) |
| 24 | 2953 | 8.2% |
| 26 | 2871 | 8.0% |
| 22 | 2723 | 7.6% |
| 23 | 2545 | 7.1% |
| 20 | 2351 | 6.5% |
| 25 | 2104 | 5.9% |
| 17 | 2098 | 5.8% |
| 27 | 1718 | 4.8% |
| 28 | 1678 | 4.7% |
| 19 | 1668 | 4.6% |
| Other values (39) | 13243 |
| Value | Count | Frequency (%) |
| 9 | 10 | < 0.1% |
| 10 | 60 | 0.2% |
| 11 | 59 | 0.2% |
| 12 | 255 | 0.7% |
| 13 | 280 | 0.8% |
| 14 | 443 | 1.2% |
| 15 | 842 | |
| 16 | 1281 | |
| 17 | 2098 | |
| 18 | 1570 |
| Value | Count | Frequency (%) |
| 61 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 59 | 2 | < 0.1% |
| 58 | 3 | < 0.1% |
| 53 | 3 | < 0.1% |
| 52 | 6 | |
| 51 | 4 | < 0.1% |
| 50 | 4 | < 0.1% |
| 49 | 14 | |
| 48 | 11 |
| Distinct | 46 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 19.92932243 |
| Minimum | 7 |
|---|---|
| Maximum | 56 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 7 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 16 |
| median | 19 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 56 |
| Range | 49 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 5.112408945 |
|---|---|
| Coefficient of variation (CV) | 0.2565269824 |
| Kurtosis | 2.722551335 |
| Mean | 19.92932243 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 1.067772702 |
| Sum | 716499 |
| Variance | 26.13672522 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=46)
| Value | Count | Frequency (%) |
| 18 | 3559 | 9.9% |
| 19 | 3282 | 9.1% |
| 21 | 3158 | 8.8% |
| 20 | 3093 | 8.6% |
| 17 | 2420 | 6.7% |
| 16 | 2315 | 6.4% |
| 22 | 2247 | 6.2% |
| 15 | 2241 | 6.2% |
| 14 | 1947 | 5.4% |
| 23 | 1794 | 5.0% |
| Other values (36) | 9896 |
| Value | Count | Frequency (%) |
| 7 | 5 | < 0.1% |
| 8 | 21 | 0.1% |
| 9 | 40 | 0.1% |
| 10 | 131 | 0.4% |
| 11 | 441 | 1.2% |
| 12 | 741 | 2.1% |
| 13 | 1255 | |
| 14 | 1947 | |
| 15 | 2241 | |
| 16 | 2315 |
| Value | Count | Frequency (%) |
| 56 | 2 | < 0.1% |
| 53 | 4 | < 0.1% |
| 52 | 5 | < 0.1% |
| 50 | 15 | |
| 48 | 2 | < 0.1% |
| 47 | 16 | |
| 46 | 11 | |
| 45 | 5 | < 0.1% |
| 44 | 5 | < 0.1% |
| 43 | 7 |
| Distinct | 575 |
|---|---|
| Distinct (%) | 1.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 475.3163393 |
| Minimum | 37 |
|---|---|
| Maximum | 1269.571429 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 37 |
|---|---|
| 5-th percentile | 306.4482759 |
| Q1 | 395 |
| median | 467.7368421 |
| Q3 | 555.4375 |
| 95-th percentile | 683.6153846 |
| Maximum | 1269.571429 |
| Range | 1232.571429 |
| Interquartile range (IQR) | 160.4375 |
Descriptive statistics
| Standard deviation | 119.0607732 |
|---|---|
| Coefficient of variation (CV) | 0.2504874405 |
| Kurtosis | 1.263582798 |
| Mean | 475.3163393 |
| Median Absolute Deviation (MAD) | 81.34553776 |
| Skewness | 0.7416918392 |
| Sum | 17088573.03 |
| Variance | 14175.46772 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 493.7222222 | 3114 | 8.7% |
| 467.7368421 | 2763 | 7.7% |
| 444.35 | 2697 | 7.5% |
| 423.1904762 | 2662 | 7.4% |
| 592.4666667 | 2023 | 5.6% |
| 555.4375 | 2022 | 5.6% |
| 522.7647059 | 2010 | 5.6% |
| 403.9545455 | 1819 | 5.1% |
| 634.7857143 | 1801 | 5.0% |
| 386.3913043 | 1367 | 3.8% |
| Other values (565) | 13674 |
| Value | Count | Frequency (%) |
| 37 | 1 | < 0.1% |
| 40 | 2 | |
| 51 | 2 | |
| 81 | 3 | |
| 84 | 1 | < 0.1% |
| 87 | 1 | < 0.1% |
| 91 | 3 | |
| 101 | 1 | < 0.1% |
| 104 | 2 | |
| 112 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1269.571429 | 5 | < 0.1% |
| 1110.875 | 21 | 0.1% |
| 987.4444444 | 36 | 0.1% |
| 888.7 | 127 | 0.4% |
| 847 | 3 | < 0.1% |
| 807.9090909 | 434 | |
| 805 | 3 | < 0.1% |
| 801 | 1 | < 0.1% |
| 790 | 1 | < 0.1% |
| 787.725 | 4 | < 0.1% |
| Distinct | 55 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1892.598465 |
| Minimum | 600 |
|---|---|
| Maximum | 5800 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 281.0 KiB |
Quantile statistics
| Minimum | 600 |
|---|---|
| 5-th percentile | 1200 |
| Q1 | 1500 |
| median | 1850 |
| Q3 | 2200 |
| 95-th percentile | 2800 |
| Maximum | 5800 |
| Range | 5200 |
| Interquartile range (IQR) | 700 |
Descriptive statistics
| Standard deviation | 506.9586274 |
|---|---|
| Coefficient of variation (CV) | 0.2678638057 |
| Kurtosis | 1.74029905 |
| Mean | 1892.598465 |
| Median Absolute Deviation (MAD) | 350 |
| Skewness | 0.8345314918 |
| Sum | 68042700 |
| Variance | 257007.0499 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1850 | 2849 | 7.9% |
| 1950 | 2818 | 7.8% |
| 1600 | 2297 | 6.4% |
| 1750 | 2271 | 6.3% |
| 2400 | 2086 | 5.8% |
| 1650 | 1935 | 5.4% |
| 2200 | 1765 | 4.9% |
| 1500 | 1706 | 4.7% |
| 2100 | 1607 | 4.5% |
| 2550 | 1512 | 4.2% |
| Other values (45) | 15106 |
| Value | Count | Frequency (%) |
| 600 | 2 | < 0.1% |
| 650 | 24 | 0.1% |
| 700 | 29 | 0.1% |
| 750 | 13 | < 0.1% |
| 800 | 75 | 0.2% |
| 850 | 77 | 0.2% |
| 900 | 84 | 0.2% |
| 950 | 66 | 0.2% |
| 1000 | 248 | |
| 1050 | 420 |
| Value | Count | Frequency (%) |
| 5800 | 5 | < 0.1% |
| 5050 | 4 | < 0.1% |
| 4500 | 6 | < 0.1% |
| 4150 | 17 | < 0.1% |
| 4050 | 53 | 0.1% |
| 3700 | 176 | |
| 3400 | 232 | |
| 3350 | 81 | 0.2% |
| 3100 | 338 | |
| 3050 | 294 |
Auto
The auto setting is an easily interpretable pairwise column metric of the following mapping: vartype-vartype : method, categorical-categorical : Cramer's V, numerical-categorical : Cramer's V (using a discretized numerical column), numerical-numerical : Spearman's ρ. This configuration uses the best suitable for each pair of columns.Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
First rows
| Make | Model | Year | Engine Displacement | Cylinders | Transmission | Drivetrain | Vehicle Class | Fuel Type | Fuel Barrels/Year | City MPG | Highway MPG | Combined MPG | CO2 Emission Grams/Mile | Fuel Cost/Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | AM General | DJ Po Vehicle 2WD | 1984 | 2.5 | 4.0 | Automatic 3-spd | 2-Wheel Drive | Special Purpose Vehicle 2WD | Regular | 19.388824 | 18 | 17 | 17 | 522.764706 | 1950 |
| 1 | AM General | FJ8c Post Office | 1984 | 4.2 | 6.0 | Automatic 3-spd | 2-Wheel Drive | Special Purpose Vehicle 2WD | Regular | 25.354615 | 13 | 13 | 13 | 683.615385 | 2550 |
| 2 | AM General | Post Office DJ5 2WD | 1985 | 2.5 | 4.0 | Automatic 3-spd | Rear-Wheel Drive | Special Purpose Vehicle 2WD | Regular | 20.600625 | 16 | 17 | 16 | 555.437500 | 2100 |
| 3 | AM General | Post Office DJ8 2WD | 1985 | 4.2 | 6.0 | Automatic 3-spd | Rear-Wheel Drive | Special Purpose Vehicle 2WD | Regular | 25.354615 | 13 | 13 | 13 | 683.615385 | 2550 |
| 4 | ASC Incorporated | GNX | 1987 | 3.8 | 6.0 | Automatic 4-spd | Rear-Wheel Drive | Midsize Cars | Premium | 20.600625 | 14 | 21 | 16 | 555.437500 | 2550 |
| 5 | Acura | 2.2CL/3.0CL | 1997 | 2.2 | 4.0 | Automatic 4-spd | Front-Wheel Drive | Subcompact Cars | Regular | 14.982273 | 20 | 26 | 22 | 403.954545 | 1500 |
| 6 | Acura | 2.2CL/3.0CL | 1997 | 2.2 | 4.0 | Manual 5-spd | Front-Wheel Drive | Subcompact Cars | Regular | 13.733750 | 22 | 28 | 24 | 370.291667 | 1400 |
| 7 | Acura | 2.2CL/3.0CL | 1997 | 3.0 | 6.0 | Automatic 4-spd | Front-Wheel Drive | Subcompact Cars | Regular | 16.480500 | 18 | 26 | 20 | 444.350000 | 1650 |
| 8 | Acura | 2.3CL/3.0CL | 1998 | 2.3 | 4.0 | Automatic 4-spd | Front-Wheel Drive | Subcompact Cars | Regular | 14.982273 | 19 | 27 | 22 | 403.954545 | 1500 |
| 9 | Acura | 2.3CL/3.0CL | 1998 | 2.3 | 4.0 | Manual 5-spd | Front-Wheel Drive | Subcompact Cars | Regular | 13.733750 | 21 | 29 | 24 | 370.291667 | 1400 |
Last rows
| Make | Model | Year | Engine Displacement | Cylinders | Transmission | Drivetrain | Vehicle Class | Fuel Type | Fuel Barrels/Year | City MPG | Highway MPG | Combined MPG | CO2 Emission Grams/Mile | Fuel Cost/Year | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35942 | smart | fortwo coupe | 2008 | 1.0 | 3.0 | Automatic (S5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 33 | 41 | 36 | 246.861111 | 1100 |
| 35943 | smart | fortwo coupe | 2009 | 1.0 | 3.0 | Automatic (AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 33 | 41 | 36 | 246.861111 | 1100 |
| 35944 | smart | fortwo coupe | 2010 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 33 | 41 | 36 | 246.861111 | 1100 |
| 35945 | smart | fortwo coupe | 2011 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 33 | 41 | 36 | 246.861111 | 1100 |
| 35946 | smart | fortwo coupe | 2012 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 34 | 38 | 36 | 246.861111 | 1100 |
| 35947 | smart | fortwo coupe | 2013 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 34 | 38 | 36 | 244.000000 | 1100 |
| 35948 | smart | fortwo coupe | 2014 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 34 | 38 | 36 | 243.000000 | 1100 |
| 35949 | smart | fortwo coupe | 2015 | 1.0 | 3.0 | Auto(AM5) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 34 | 38 | 36 | 244.000000 | 1100 |
| 35950 | smart | fortwo coupe | 2016 | 0.9 | 3.0 | Auto(AM6) | Rear-Wheel Drive | Two Seaters | Premium | 9.155833 | 34 | 39 | 36 | 246.000000 | 1100 |
| 35951 | smart | fortwo coupe | 2016 | 0.9 | 3.0 | Manual 5-spd | Rear-Wheel Drive | Two Seaters | Premium | 9.417429 | 32 | 39 | 35 | 255.000000 | 1150 |